Data Prep 1: But I Need a Trial Balance

Price: $ 14.99



This case is designed for accounting students. The case introduces students to the essence of ETL software, extracting data from Excel, transforming data and loading the results into Excel. The transformation of the General Journal data includes removing rows, removing columns, sorting, rearranging columns and creating a running balance. Then the students load a general ledger and an unadjusted trial balance back into Excel. Next, students must answer a set of analytic questions from their Excel file. The numbers are unique to each student. As a result, the correct answers to the analytic questions will be different and unique for every student. The case can be solved using Alteryx, Power BI or Tableau and a free mini tutorial and data set is available.

Table of contents

View chapter in pdf form

View chapter in ppt form

The book comes with a quizzing system, with each student being presented with a timed quiz comprising five questions selected at random from the database of quiz questions for the chapter. Instructors can assign these quizzes in advance of the topics to be covered in class, giving students an incentive to read the chapter in advance of the class. Students read the chapters and take the online quizzes prior to class.

Each chapter features hyperlinks to related information, taking advantage of the online nature of the book. Additionally, the chapters featuring Microsoft Access databases permit the databases to be downloaded by students for further exploration.

The following are some of the resources available for adopting instructors:

  • Solutions to end-of-chapter questions and problems
  • The ability to make selected solutions available to students
  • The ability to view all quiz questions for a chapter
  • The ability to generate quiz grade reports
  • Sample tests
  • Powerpoint files for each chapter

Videos Demo

Other products


E-Books

No Image Available.
No Image Available.
No Image Available.

Analytics Products

No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.

Excel Accounting Practice Sets

No Image Available.
No Image Available.
No Image Available.
No Image Available.